Skip to main content

Chatbot Event Log Report

Type of Report -

Standard

Purpose of the Report -

This report contains 2 worksheets-

i) Overall : The purpose of this worksheet is mainly to fetch the name and count of all the events triggered in a session of any platform except whatsapp.

ii) Unidentified : This worksheet contains the information about the count of the some specific event when they are triggered in a session except whatsapp

Detailed Description -

i) Overall

Name of ColumnDescription of FieldWhere is the value fetched from
Events TagsConcat of event name and event typeevent_logs(sessionFlow)
CountNo of times that event tag occurs within a sessionevent_logs
Custom Menu LinkedEvent nameevent_logs

The aggregation is written where lookup is implemented on chat_sessions based on session_id to remove session where platform== “whatsapp”.

ii) msisdn query

Name of ColumnDescription of FieldWhere is the value fetched from
Events TagsConcat of event name and event typeevent_logs(sessionFlow)
CountNo of times that event tag occurs within a sessionevent_logs
Custom Menu LinkedEvent nameevent_logs

Example of Report -

Report Link : https://docs.google.com/spreadsheets/d/16YFhRokBP5gUUBkgqXYKZ7HNkaqb0GlJxfznn7ADIJw/edit?usp=sharing

Report Format -

Branch : development

Path : Reports/eventLogChatbotReport.js

Aggregation -

Branch : development

Path : Reports//eventLogChatbot.js